Tabela TimeSlot

Definicja tabeli TimeSlot

Name

TimeSlot

Code

TimeSlot

Comment

PL: Dane przedzialów czasowych
EN: Time slots definition


Lista kolumn tabeli TimeSlot

Name

Code

TimeSlotID

TimeSlotID

DayID

DayID

TimeslotTypeID

TimeslotTypeID

TimeSlotStatusID

TimeSlotStatusID

StartT

StartT

StopT

StopT

Active

Active

Modifications

Modifications

Maximum

Maximum

Reserved

Reserved

Blocked

Blocked

PaidOvertime

PaidOvertime


Kolumna TimeSlotID tabeli TimeSlot

Definicja kolumny TimeSlotID tabeli TimeSlot

Name

TimeSlotID

Code

TimeSlotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DayID tabeli TimeSlot

Definicja kolumny DayID tabeli TimeSlot

Name

DayID

Code

DayID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TimeslotTypeID tabeli TimeSlot

Definicja kolumny TimeslotTypeID tabeli TimeSlot

Name

TimeslotTypeID

Code

TimeslotTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TimeSlotStatusID tabeli TimeSlot

Definicja kolumny TimeSlotStatusID tabeli TimeSlot

Name

TimeSlotStatusID

Code

TimeSlotStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartT tabeli TimeSlot

Definicja kolumny StartT tabeli TimeSlot

Name

StartT

Code

StartT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopT tabeli TimeSlot

Definicja kolumny StopT tabeli TimeSlot

Name

StopT

Code

StopT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli TimeSlot

Definicja kolumny Active tabeli TimeSlot

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Modifications tabeli TimeSlot

Definicja kolumny Modifications tabeli TimeSlot

Name

Modifications

Code

Modifications

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Maximum tabeli TimeSlot

Definicja kolumny Maximum tabeli TimeSlot

Name

Maximum

Code

Maximum

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Reserved tabeli TimeSlot

Definicja kolumny Reserved tabeli TimeSlot

Name

Reserved

Code

Reserved

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Blocked tabeli TimeSlot

Definicja kolumny Blocked tabeli TimeSlot

Name

Blocked

Code

Blocked

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PaidOvertime tabeli TimeSlot

Definicja kolumny PaidOvertime tabeli TimeSlot

Name

PaidOvertime

Code

PaidOvertime

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli TimeSlot

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TimeSlot

Definicja klucza Identifier_1 tabeli TimeSlot

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment